Gigarom 4

home *** CD-ROM | disk | FTP | other *** search

/ Gigarom 4 / Mac Giga-ROM 4.0 - 1993.toast / FILES / BUS / A-E / BASIC BILLING.sea / BASIC BILLING / Billing (.txt) next >

Wrap

FileMaker Pro Database | 1990-11-04 | 39.5 KB | 292 lines | [FMK$/FMK4]

PLEASE PAY HBAM2001MAY84 123-4567 765-4321 Apartments Bambi Crossing Drive Drive Deerfield Deerhaven 12345 54321 Antler Cleaner Fur-so-soft Haunches Shampoo Company Address Address State Company Telephone 4.01I 11/3/90 ACCOUNTNO ADDRESS 1 ADDRESS 2 AMT PAID CITY STATE COMPADDR1 COMPADDR2 COMPCITYSTATEZIP COMPNAME COMPPHONE CURRENT CURRENTSUM DESCRIPTION INVOICE DATE INVOICE NO NINETY $ NINETYSUM ONE_TWENTY ONE_TWENTYSUM PHONE PLEASE PAY QUANTITY REF DATE SIXTY SIXTYSUM STMT AMT PAID STMT PLEASE PAY STMT TAX DUE STMT TOTAL DUE STMT TOTALPLUSTAX TAXDUE TAXRATE THIRTY " THIRTYSUM TOTAL TOTAL DUE TOTALPLUSTAX PhoneB A AccountNoB Customers NameB Customers A Address 1B Customers A Address 2B Customers City StateB Customers Customers Invoice NoB Invoice DateB DescriptionB QuantityB RateB TotalB round(Quantity * Rate,2)F Amt PaidB Please PayB TotalPlusTax- Amt PaidF A Total DueB sum(Total)F TaxRateB Company Data TaxDueB round(TaxRate * Total Due,2)F TotalPlusTaxB Total Due + TaxDueF Stmt Total DueB Stmt Tax DueB Stmt TotalPlusTaxB Stmt Amt PaidB Stmt Please PayB CompNameB Company Data A CompAddr1B Company Data A CompAddr2B Company Data CompCityStateZipB Company Data A CompPhoneB Company Data Ref DateB E:if(REF DATE - Invoice Date > 0, REF DATE - Invoice Date,0)F" CurrentB if(Age <30,Please Pay,0)F ThirtyB E&if(Age >=30 and Age < 60,Please Pay,0) SixtyB E)if(Age >= 60 and Age <= 90, Please Pay,0)F( NinetyB E)if(Age >= 90 and Age < 120, Please Pay,0)F( One_TwentyB if(Age >= 120, Please Pay, 0)F CurrentSumB 'A ThirtySumB SixtySumB )A NinetySumB One_TwentySumB STATEMENT DATE: // DATE NUMBER DESCRIPTION PRICE EA. TOTAL SUB TOTAL TOTAL DUE PAYMENT BALANCE DUE STATEMENT DATE: // DATE NUMBER DESCRIPTION PRICE EA. TOTAL SUB TOTAL TOTAL DUE PAYMENT BALANCE DUE INVOICE DATE: DESCRIPTION PRICE EA. TOTAL SUB TOTAL TOTAL DUE PAYMENT BALANCE DUE INVOICE DATE: DESCRIPTION PRICE EA. TOTAL SUB TOTAL TOTAL DUE PAYMENT BALANCE DUE DATE: SubTtl Acct. No. Total Payment Balance DESCRIPTION PRICE EA. TOTAL DATE: SubTtl Acct. No. Total PLEASE PAY Payment Balance DESCRIPTION PRICE EA. TOTAL AGING REPORT Account Current 30 Days 60 Days 90 Days 120 Days Total Due Totals Page ## AGING REPORT Account Current 30 Days 60 Days 90 Days 120 Days Total Due Totals Page ## Enter the aging date then press Command = At the prompt, click on Replace. Enter the aging date then press Command = At the prompt, click on Replace. 123-4567B John DoeD 123 Deer Crossing Drive.F Deerhaven, DEG 12345H 1/1/91J Antler Wax Hoof CleanerK 1.25M 6.25O 10.06P 8.75Q 1.31S 10.06Y Company Name Goes HereZ Address 1[ Address 2\ City State and Zip] Company Telephone^ 1/31/91` 10.06c 765-4321B 2C Jane BuckD No. 1 Bambi ApartmentsE 789 Fawn DriveF Deerfield, DEG 54321H 1/1/91J Fur-So-SoftK 11.50O 11.5Y Company Name Goes HereZ Address 1[ Address 2\ City State and Zip] Company Telephone^ 1/31/91` 123-4567B John DoeD 123 Deer Crossing Drive.F Deerhaven, DEG 12345H 11/3/90J Head & Haunches ShampooK 2.75M 8.25N 9.49O 8.25Q 1.24S 9.49Y Company Name Goes Here Z Address 1[ Address 2\ City State and Zip] Company Telephone^ Create Invoice sample Print Invoice sample Print Statements Age Accounts Print Aging Report 'bQa2 4.01F# 4.01I 11/3/90 ACCOUNTNO ADDRESS 1 ADDRESS 2 AMT PAID CITY STATE COMPADDR1 COMPADDR2 COMPCITYSTATEZIP COMPNAME COMPPHONE CURRENT CURRENTSUM DESCRIPTION INVOICE DATE INVOICE NO NINETY $ NINETYSUM ONE_TWENTY ONE_TWENTYSUM PHONE